
BEGIN
	EXEC qa_drop_table FileDefinition
END 

CREATE TABLE [dbo].[FileDefinition](
	[FileID] [bigint] IDENTITY(1,1) NOT NULL,
	[OutFileName] [nchar](30) NOT NULL,
	[FileDesc] [nchar](60) NULL,
	[OutFilePath] [nchar](100) NULL,
	[OutFileExt] [nchar](4) NOT NULL,
	[FileTable] [nchar](20) NULL,
	[InFilePath] [nchar](100) NULL,
	[InFileName] [nchar](60) NULL,
	[InFileExt] [nchar](4) NULL,
	[Seperator] [nchar](10) NULL,
 CONSTRAINT [PK_FileDefinition] PRIMARY KEY CLUSTERED 
(
	[FileID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
 CONSTRAINT [UK_FileDefinition] UNIQUE NONCLUSTERED 
(
	[OutFileName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[FileDefinition] ADD  CONSTRAINT [DF_FileDefinition_FileTable]  DEFAULT (N'FileTemp') FOR [FileTable]
GO

